SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{c9a143190d154860dfd448d2729dca90e59183c29bb8345dd00d812b9fb8688c}Calonge{c9a143190d154860dfd448d2729dca90e59183c29bb8345dd00d812b9fb8688c}' OR prCity = 'Calonge' OR prZip = 'Calonge' OR prStreet LIKE '{c9a143190d154860dfd448d2729dca90e59183c29bb8345dd00d812b9fb8688c}Calonge{c9a143190d154860dfd448d2729dca90e59183c29bb8345dd00d812b9fb8688c}' OR prCountry = 'Calonge') AND (prLocation LIKE '{c9a143190d154860dfd448d2729dca90e59183c29bb8345dd00d812b9fb8688c}Spain{c9a143190d154860dfd448d2729dca90e59183c29bb8345dd00d812b9fb8688c}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{c9a143190d154860dfd448d2729dca90e59183c29bb8345dd00d812b9fb8688c}Spain{c9a143190d154860dfd448d2729dca90e59183c29bb8345dd00d812b9fb8688c}' OR prCountry = 'Spain')